Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	7194164
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	713.5 MiB
Average record size in memory	104.0 B

Variable types

Numeric	11
Categorical	1

Alerts

`acceleration_y` is highly correlated with `acceleration_z`	High correlation
`acceleration_z` is highly correlated with `acceleration_y`	High correlation
`Accuracy` is highly skewed (γ1 = 20.92819319)	Skewed
`Bearing` has 588974 (8.2%) zeros	Zeros
`Speed` has 1235824 (17.2%) zeros	Zeros

Reproduction

Analysis started	2021-12-10 12:46:33.803935
Analysis finished	2021-12-10 12:58:29.680531
Duration	11 minutes and 55.88 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

bookingID
Real number (ℝ_≥0)

Distinct	19962
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.182723734 × 10¹¹

Minimum	0
Maximum	1.709396984 × 10¹²
Zeros	443
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	109.8 MiB

Quantile statistics

Minimum	0
5-th percentile	7.730941134 × 10¹⁰
Q1	3.779571222 × 10¹¹
median	8.074538517 × 10¹¹
Q3	1.25413045 × 10¹²
95-th percentile	1.606317769 × 10¹²
Maximum	1.709396984 × 10¹²
Range	1.709396984 × 10¹²
Interquartile range (IQR)	8.761733282 × 10¹¹

Descriptive statistics

Standard deviation	4.951463486 × 10¹¹
Coefficient of variation (CV)	0.6051118976
Kurtosis	-1.211616157
Mean	8.182723734 × 10¹¹
Median Absolute Deviation (MAD)	4.294967295 × 10¹¹
Skewness	0.07856802874
Sum	5.886785651 × 10¹⁸
Variance	2.451699066 × 10²³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.380866644 × 10¹¹	3267	< 0.1%
1.374389535 × 10¹²	2021	< 0.1%
3.435973847 × 10¹⁰	1813	< 0.1%
1.108101563 × 10¹²	1804	< 0.1%
7.473243096 × 10¹¹	1696	< 0.1%
1.486058684 × 10¹²	1617	< 0.1%
8.933531977 × 10¹¹	1550	< 0.1%
1.3657996 × 10¹²	1472	< 0.1%
1.211180778 × 10¹²	1407	< 0.1%
1.202590845 × 10¹¹	1401	< 0.1%
Other values (19952)	7176116	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	443	< 0.1%
1	389	< 0.1%
2	81	< 0.1%
4	477	< 0.1%
6	507	< 0.1%
7	436	< 0.1%
8	186	< 0.1%
10	170	< 0.1%
11	98	< 0.1%
14	274	< 0.1%

Value	Count	Frequency (%)
1.709396984 × 10¹²	181	< 0.1%
1.709396984 × 10¹²	474	< 0.1%
1.709396984 × 10¹²	337	< 0.1%
1.709396984 × 10¹²	332	< 0.1%
1.709396984 × 10¹²	391	< 0.1%
1.709396984 × 10¹²	109	< 0.1%
1.709396984 × 10¹²	428	< 0.1%
1.709396984 × 10¹²	250	< 0.1%
1.709396984 × 10¹²	1275	< 0.1%
1.709396984 × 10¹²	451	< 0.1%

Accuracy
Real number (ℝ_≥0)

SKEWED

Distinct	38396
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.10795164

Minimum	0.75
Maximum	1500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	109.8 MiB

Quantile statistics

Minimum	0.75
5-th percentile	3
Q1	3.9
median	4.162
Q3	8
95-th percentile	16
Maximum	1500
Range	1499.25
Interquartile range (IQR)	4.1

Descriptive statistics

Standard deviation	62.55569067
Coefficient of variation (CV)	6.188760385
Kurtosis	452.6193014
Mean	10.10795164
Median Absolute Deviation (MAD)	1.162
Skewness	20.92819319
Sum	72718261.78
Variance	3913.214435
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.9	1294112	18.0%
3	890962	12.4%
4	845323	11.8%
10	566057	7.9%
6	549389	7.6%
8	496499	6.9%
12	194376	2.7%
16	179944	2.5%
5	131821	1.8%
9	76045	1.1%
Other values (38386)	1969636	27.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.75	6	< 0.1%
0.8	27	< 0.1%
0.9	139	< 0.1%
1	336	< 0.1%
1.1	54	< 0.1%
1.2	125	< 0.1%
1.3	192	< 0.1%
1.4	144	< 0.1%
1.5	485	< 0.1%
1.6	143	< 0.1%

Value	Count	Frequency (%)
1500	63	< 0.1%
1497.855	1	< 0.1%
1497.177	1	< 0.1%
1489.331	1	< 0.1%
1487	29	< 0.1%
1486.769	1	< 0.1%
1485	2	< 0.1%
1482.418	1	< 0.1%
1479	36	< 0.1%
1478.243	1	< 0.1%

Bearing
Real number (ℝ_≥0)

ZEROS

Distinct	1059499
Distinct (%)	14.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	165.2125067

Minimum	0
Maximum	359.9994812
Zeros	588974
Zeros (%)	8.2%
Negative	0
Negative (%)	0.0%
Memory size	109.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	73
median	164
Q3	260.3179169
95-th percentile	338
Maximum	359.9994812
Range	359.9994812
Interquartile range (IQR)	187.3179169

Descriptive statistics

Standard deviation	108.9644246
Coefficient of variation (CV)	0.6595410162
Kurtosis	-1.230906131
Mean	165.2125067
Median Absolute Deviation (MAD)	94
Skewness	0.04111357366
Sum	1188565868
Variance	11873.24582
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	588974	8.2%
268	25332	0.4%
88	24413	0.3%
119	24299	0.3%
118	22586	0.3%
122	22521	0.3%
254	22339	0.3%
267	21093	0.3%
121	20918	0.3%
299	20355	0.3%
Other values (1059489)	6401334	89.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	588974	8.2%
0.001205474138	1	< 0.1%
0.001504063606	7	< 0.1%
0.001616671681	2	< 0.1%
0.002067267895	1	< 0.1%
0.002399995923	1	< 0.1%
0.002684906125	1	< 0.1%
0.003095075488	6	< 0.1%
0.003160491586	1	< 0.1%
0.003383740783	2	< 0.1%

Value	Count	Frequency (%)
359.9994812	1	< 0.1%
359.9985046	1	< 0.1%
359.9984741	4	< 0.1%
359.9979248	2	< 0.1%
359.9973755	1	< 0.1%
359.9969482	1	< 0.1%
359.9955139	1	< 0.1%
359.9953308	1	< 0.1%
359.995	1	< 0.1%
359.9949036	2	< 0.1%

acceleration_x
Real number (ℝ)

Distinct	990842
Distinct (%)	13.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06777408473

Minimum	-9.999999
Maximum	13.3964945
Zeros	6927
Zeros (%)	0.1%
Negative	3368295
Negative (%)	46.8%
Memory size	109.8 MiB

Quantile statistics

Minimum	-9.999999
5-th percentile	-1.7645805
Q1	-0.50517654
median	0.06190795898
Q3	0.63206923
95-th percentile	1.892
Maximum	13.3964945
Range	23.3964935
Interquartile range (IQR)	1.13724577

Descriptive statistics

Standard deviation	1.350014832
Coefficient of variation (CV)	19.91933697
Kurtosis	13.02719684
Mean	0.06777408473
Median Absolute Deviation (MAD)	0.568322591
Skewness	0.2185292787
Sum	487577.8805
Variance	1.822540046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6927	0.1%
0.045491222	3736	0.1%
0.083799616	3725	0.1%
0.08140534	2737	< 0.1%
0.08619389	2647	< 0.1%
0.043096945	2606	< 0.1%
0.047885496	2597	< 0.1%
0.098165266	2572	< 0.1%
0.08858817	2569	< 0.1%
0.05027977	2534	< 0.1%
Other values (990832)	7161514	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-9.999999	1	< 0.1%
-9.99971	1	< 0.1%
-9.999383	3	< 0.1%
-9.999032593	1	< 0.1%
-9.998642	1	< 0.1%
-9.998491	1	< 0.1%
-9.998284912	1	< 0.1%
-9.998161	1	< 0.1%
-9.998	1	< 0.1%
-9.997708	1	< 0.1%

Value	Count	Frequency (%)
13.3964945	1	< 0.1%
12.60073118	1	< 0.1%
12.43206977	1	< 0.1%
12.40322202	1	< 0.1%
12.19356958	1	< 0.1%
12.18773802	1	< 0.1%
12.16536558	1	< 0.1%
11.60711025	1	< 0.1%
11.59716403	1	< 0.1%
11.33954875	1	< 0.1%

acceleration_y
Real number (ℝ)

HIGH CORRELATION

Distinct	922232
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.457620292

Minimum	-19.99507446
Maximum	24.939201
Zeros	166
Zeros (%)	< 0.1%
Negative	1868136
Negative (%)	26.0%
Memory size	109.8 MiB

Quantile statistics

Minimum	-19.99507446
5-th percentile	-9.894955444
Q1	-1.925576782
median	9.088211
Q3	9.709717
95-th percentile	10.433931
Maximum	24.939201
Range	44.93427546
Interquartile range (IQR)	11.63529378

Descriptive statistics

Standard deviation	8.068016364
Coefficient of variation (CV)	1.809938002
Kurtosis	-0.7401543253
Mean	4.457620292
Median Absolute Deviation (MAD)	0.850424
Skewness	-1.064893748
Sum	32068851.43
Variance	65.09288805
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.775824	3816	0.1%
9.73991	3808	0.1%
9.742304	3802	0.1%
9.727939	3781	0.1%
9.737515	3779	0.1%
9.768641	3731	0.1%
9.70639	3713	0.1%
9.735122	3711	0.1%
9.732727	3700	0.1%
9.747093	3698	0.1%
Other values (922222)	7156625	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-19.99507446	1	< 0.1%
-19.886847	1	< 0.1%
-19.82250977	1	< 0.1%
-19.77720032	1	< 0.1%
-19.73802185	1	< 0.1%
-19.73233948	1	< 0.1%
-19.68299255	1	< 0.1%
-19.61480408	1	< 0.1%
-19.6133	2	< 0.1%
-19.57009277	1	< 0.1%

Value	Count	Frequency (%)
24.939201	1	< 0.1%
24.919613	1	< 0.1%
24.873	1	< 0.1%
24.724682	1	< 0.1%
24.663425	1	< 0.1%
24.574	1	< 0.1%
24.524597	1	< 0.1%
24.421602	1	< 0.1%
24.416815	1	< 0.1%
24.256222	1	< 0.1%

acceleration_z
Real number (ℝ)

HIGH CORRELATION

Distinct	1328887
Distinct (%)	18.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.8896587715

Minimum	-14.99623108
Maximum	14.999435
Zeros	2081
Zeros (%)	< 0.1%
Negative	2729004
Negative (%)	37.9%
Memory size	109.8 MiB

Quantile statistics

Minimum	-14.99623108
5-th percentile	-4.188357544
Q1	-0.923310125
median	0.7781393
Q3	2.7458439
95-th percentile	6.070498065
Maximum	14.999435
Range	29.99566608
Interquartile range (IQR)	3.669154025

Descriptive statistics

Standard deviation	3.173510117
Coefficient of variation (CV)	3.567109344
Kurtosis	1.116102528
Mean	0.8896587715
Median Absolute Deviation (MAD)	1.823695941
Skewness	0.008618377417
Sum	6400351.106
Variance	10.07116646
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2081	< 0.1%
-0.08858817	1015	< 0.1%
-0.05027977	1005	< 0.1%
1.1779832	854	< 0.1%
1.2905141	834	< 0.1%
-0.9122187	824	< 0.1%
1.0654523	824	< 0.1%
1.211503	819	< 0.1%
0.41420954	817	< 0.1%
0.4932206	816	< 0.1%
Other values (1328877)	7184275	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-14.99623108	1	< 0.1%
-14.98860474	1	< 0.1%
-14.97888489	1	< 0.1%
-14.97798767	1	< 0.1%
-14.976189	2	< 0.1%
-14.96423035	1	< 0.1%
-14.95720215	1	< 0.1%
-14.95705261	1	< 0.1%
-14.95600586	1	< 0.1%
-14.95555725	1	< 0.1%

Value	Count	Frequency (%)
14.999435	1	< 0.1%
14.993759	1	< 0.1%
14.993301	1	< 0.1%
14.990555	1	< 0.1%
14.985766	2	< 0.1%
14.985657	1	< 0.1%
14.983372	1	< 0.1%
14.982316	1	< 0.1%
14.978126	2	< 0.1%
14.977915	1	< 0.1%

gyro_x
Real number (ℝ)

Distinct	2039457
Distinct (%)	28.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.001738068972

Minimum	-0.9998474
Maximum	1.311228297
Zeros	19937
Zeros (%)	0.3%
Negative	3697871
Negative (%)	51.4%
Memory size	109.8 MiB

Quantile statistics

Minimum	-0.9998474
5-th percentile	-0.136856839
Q1	-0.02654852027
median	-0.00065484754
Q3	0.023071289
95-th percentile	0.13194689
Maximum	1.311228297
Range	2.311075697
Interquartile range (IQR)	0.04961980927

Descriptive statistics

Standard deviation	0.1000226227
Coefficient of variation (CV)	-57.54813204
Kurtosis	17.42008449
Mean	-0.001738068972
Median Absolute Deviation (MAD)	0.02479807354
Skewness	-0.006271419179
Sum	-12503.95323
Variance	0.01000452505
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19937	0.3%
-0.0012217305	8225	0.1%
0.0012217305	7626	0.1%
-0.002443461	7141	0.1%
0.002443461	6615	0.1%
-0.004886922	5520	0.1%
0.004886922	5342	0.1%
-0.0061086523	4686	0.1%
0.0061086523	4681	0.1%
0.008552114	4495	0.1%
Other values (2039447)	7119896	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.9998474	1	< 0.1%
-0.9998342965	1	< 0.1%
-0.9998220459	1	< 0.1%
-0.99974203	1	< 0.1%
-0.9997406	1	< 0.1%
-0.99971026	1	< 0.1%
-0.9996948	1	< 0.1%
-0.99967223	1	< 0.1%
-0.9996543	1	< 0.1%
-0.99965066	1	< 0.1%

Value	Count	Frequency (%)
1.311228297	1	< 0.1%
1.165097849	1	< 0.1%
1.164402489	1	< 0.1%
1.155670763	1	< 0.1%
0.9998872934	1	< 0.1%
0.9998398	1	< 0.1%
0.9998119	1	< 0.1%
0.9997988764	1	< 0.1%
0.9997567985	1	< 0.1%
0.9996993	1	< 0.1%

gyro_y
Real number (ℝ)

Distinct	2203565
Distinct (%)	30.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.000127149945

Minimum	-5.9894347
Maximum	5.99646
Zeros	18555
Zeros (%)	0.3%
Negative	3537346
Negative (%)	49.2%
Memory size	109.8 MiB

Quantile statistics

Minimum	-5.9894347
5-th percentile	-0.1753217136
Q1	-0.02970117037
median	0.0002593994
Q3	0.031083878
95-th percentile	0.1724843434
Maximum	5.99646
Range	11.9858947
Interquartile range (IQR)	0.06078504837

Descriptive statistics

Standard deviation	0.1781302481
Coefficient of variation (CV)	-1400.946325
Kurtosis	222.4634773
Mean	-0.000127149945
Median Absolute Deviation (MAD)	0.0304012354
Skewness	-0.05436814525
Sum	-914.7375568
Variance	0.03173038529
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18555	0.3%
-0.0012217305	7083	0.1%
0.0012217305	7074	0.1%
-0.002443461	6287	0.1%
0.002443461	6103	0.1%
-0.004886922	4974	0.1%
0.004886922	4731	0.1%
-0.0061086523	4239	0.1%
0.0061086523	4011	0.1%
-0.008552114	3968	0.1%
Other values (2203555)	7127139	99.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-5.9894347	1	< 0.1%
-5.9845304	1	< 0.1%
-5.9844604	1	< 0.1%
-5.9823065	1	< 0.1%
-5.976064	1	< 0.1%
-5.973808	1	< 0.1%
-5.9728804	1	< 0.1%
-5.9611077	1	< 0.1%
-5.952407	1	< 0.1%
-5.949878	1	< 0.1%

Value	Count	Frequency (%)
5.99646	1	< 0.1%
5.9909887	1	< 0.1%
5.9909363	1	< 0.1%
5.9891324	1	< 0.1%
5.9860353	1	< 0.1%
5.9837646	1	< 0.1%
5.977267	1	< 0.1%
5.9770174	1	< 0.1%
5.9718714	1	< 0.1%
5.970157	1	< 0.1%

gyro_z
Real number (ℝ)

Distinct	1746404
Distinct (%)	24.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.0003658102102

Minimum	-6.9389644
Maximum	6.690163193
Zeros	22688
Zeros (%)	0.3%
Negative	3602888
Negative (%)	50.1%
Memory size	109.8 MiB

Quantile statistics

Minimum	-6.9389644
5-th percentile	-0.09352112
Q1	-0.018467678
median	-2.4430454 × 10^-5
Q3	0.0181091
95-th percentile	0.09188748676
Maximum	6.690163193
Range	13.62912759
Interquartile range (IQR)	0.036576778

Descriptive statistics

Standard deviation	0.102658583
Coefficient of variation (CV)	-280.6334544
Kurtosis	396.894181
Mean	-0.0003658102102
Median Absolute Deviation (MAD)	0.01830137555
Skewness	-0.6651113066
Sum	-2631.698645
Variance	0.01053878466
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	22688	0.3%
0.0012217305	8481	0.1%
-0.0012217305	7925	0.1%
0.002443461	7299	0.1%
-0.002443461	7189	0.1%
-0.004886922	5983	0.1%
0.004886922	5914	0.1%
-0.0061086523	5476	0.1%
-0.008552114	5006	0.1%
0.0061086523	4948	0.1%
Other values (1746394)	7113255	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-6.9389644	1	< 0.1%
-6.919204	1	< 0.1%
-6.8659306	1	< 0.1%
-6.809573	1	< 0.1%
-6.7360487	1	< 0.1%
-6.702616667	1	< 0.1%
-6.696601	1	< 0.1%
-6.5187855	1	< 0.1%
-6.3872037	1	< 0.1%
-6.354958	1	< 0.1%

Value	Count	Frequency (%)
6.690163193	1	< 0.1%
6.6063447	1	< 0.1%
6.6058373	1	< 0.1%
6.6015024	1	< 0.1%
6.4917173	1	< 0.1%
6.428613	1	< 0.1%
6.424487	1	< 0.1%
6.390509	1	< 0.1%
6.287842	1	< 0.1%
6.143259095	1	< 0.1%

second
Real number (ℝ_≥0)

Distinct	6090
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	600.8619229

Minimum	0
Maximum	8234
Zeros	8840
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	109.8 MiB

Quantile statistics

Minimum	0
5-th percentile	43
Q1	241
median	519
Q3	861
95-th percentile	1437
Maximum	8234
Range	8234
Interquartile range (IQR)	620

Descriptive statistics

Standard deviation	461.5591954
Coefficient of variation (CV)	0.7681618318
Kurtosis	8.746515994
Mean	600.8619229
Median Absolute Deviation (MAD)	303
Skewness	1.573518271
Sum	4322699215
Variance	213036.8909
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8840	0.1%
12	8526	0.1%
8	8504	0.1%
6	8503	0.1%
10	8476	0.1%
5	8449	0.1%
2	8448	0.1%
14	8445	0.1%
20	8428	0.1%
9	8422	0.1%
Other values (6080)	7109123	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8840	0.1%
1	8325	0.1%
2	8448	0.1%
3	8336	0.1%
4	8399	0.1%
5	8449	0.1%
6	8503	0.1%
7	8267	0.1%
8	8504	0.1%
9	8422	0.1%

Value	Count	Frequency (%)
8234	1	< 0.1%
8233	1	< 0.1%
8232	1	< 0.1%
8230	1	< 0.1%
8228	1	< 0.1%
8223	1	< 0.1%
8219	1	< 0.1%
8216	1	< 0.1%
8215	1	< 0.1%
8213	1	< 0.1%

Speed
Real number (ℝ)

ZEROS

Distinct	3103928
Distinct (%)	43.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.022868019

Minimum	-15.47626758
Maximum	92.44881638
Zeros	1235824
Zeros (%)	17.2%
Negative	100931
Negative (%)	1.4%
Memory size	109.8 MiB

Quantile statistics

Minimum	-15.47626758
5-th percentile	0
Q1	1.042856475
median	7.559999943
Q3	15.4936015
95-th percentile	23.5031688
Maximum	92.44881638
Range	107.925084
Interquartile range (IQR)	14.45074502

Descriptive statistics

Standard deviation	8.104774683
Coefficient of variation (CV)	0.8982481697
Kurtosis	-0.9499395382
Mean	9.022868019
Median Absolute Deviation (MAD)	7.067878723
Skewness	0.5014910725
Sum	64911992.28
Variance	65.68737267
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1235824	17.2%
-1	99101	1.4%
0.5	4974	0.1%
1	3809	0.1%
1.5	2920	< 0.1%
0.25	2732	< 0.1%
2	2672	< 0.1%
0.75	2388	< 0.1%
2.5	2363	< 0.1%
1.25	2305	< 0.1%
Other values (3103918)	5835076	81.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-15.47626758	1	< 0.1%
-15.10753315	1	< 0.1%
-10.62225	1	< 0.1%
-10.37766769	1	< 0.1%
-10.06524783	1	< 0.1%
-9.994782948	1	< 0.1%
-9.872126206	1	< 0.1%
-9.662187507	1	< 0.1%
-9.6612475	1	< 0.1%
-9.088018986	1	< 0.1%

Value	Count	Frequency (%)
92.44881638	1	< 0.1%
82.86835987	1	< 0.1%
82.75298019	1	< 0.1%
74.45287989	1	< 0.1%
73.05714399	1	< 0.1%
66.03739991	1	< 0.1%
63.36130779	1	< 0.1%
58.50670419	1	< 0.1%
57.62191993	1	< 0.1%
57.62065404	1	< 0.1%

label
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	109.8 MiB

0	5006289
1	2187875

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	5006289	69.6%
1	2187875	30.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	5006289	69.6%
1	2187875	30.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	bookingID	Accuracy	Bearing	acceleration_x	acceleration_y	acceleration_z	gyro_x	gyro_y	gyro_z	second	Speed	label
0	2.748779e+11	9.293	17.000000	0.032775	8.659933	4.737300	0.024629	0.004028	-0.010858	257.0	0.190000	1
1	1.632088e+11	10.000	262.184418	0.599490	-9.180023	-2.520432	0.026767	-0.030687	-0.006071	556.0	2.110000	0
2	1.632088e+11	3.900	247.000000	-0.178970	9.149704	3.551163	-0.006271	-0.026047	-0.012314	32.0	9.050000	1
3	2.920578e+11	4.000	248.000000	0.270553	3.270579	8.959376	-0.009404	0.023554	-0.006946	1008.0	9.497410	1
4	2.491081e+11	6.000	95.000000	-0.152798	9.903376	-0.042253	-0.006894	0.063513	0.028047	518.0	0.048665	1
5	9.448928e+10	7.627	114.000000	-0.509026	10.693520	1.033156	-0.174358	0.034837	0.024662	1250.0	23.439410	0
6	8.589935e+09	4.000	352.000000	-1.403826	10.184417	-0.607811	0.332154	0.162473	-0.033859	782.0	21.056380	1
7	4.638565e+11	12.000	73.818901	-0.793289	-8.862109	-3.120071	0.014406	0.015587	0.003032	876.0	23.222500	0
8	1.288490e+11	5.002	0.000000	-0.233435	7.514202	6.165070	-0.019743	-0.040549	-0.049944	108.0	0.000000	0
9	5.153961e+10	9.648	105.000000	-1.264862	11.337616	0.558929	0.006927	0.020798	0.010254	719.0	21.980000	0

Last rows

	bookingID	Accuracy	Bearing	acceleration_x	acceleration_y	acceleration_z	gyro_x	gyro_y	gyro_z	second	Speed	label
7194154	1.133871e+12	6.000	42.000000	0.368362	12.377152	-0.391538	0.026896	0.090635	-0.096848	1404.0	25.385725	1
7194155	1.365800e+12	8.000	0.000000	-0.202322	-8.624347	-4.963852	-0.020651	-0.036987	0.036801	611.0	28.159185	0
7194156	1.486059e+12	6.000	88.000000	-0.196331	9.172467	3.708732	0.051727	0.012014	-0.026304	1252.0	28.985123	1
7194157	1.589138e+12	6.000	355.000000	0.541106	8.755863	1.084607	0.048869	-0.066584	-0.040928	1062.0	26.868252	1
7194158	1.348620e+12	6.000	41.000000	0.120907	8.845378	4.498705	0.024435	-0.012217	0.006109	323.0	25.612532	1
7194159	1.211181e+12	11.000	119.000000	0.716465	7.281964	2.324770	-0.596548	-0.030094	0.091613	541.0	25.250000	1
7194160	1.494649e+12	4.000	0.000000	0.502798	5.810905	7.515629	0.007295	0.035505	0.026456	1637.0	27.794693	1
7194161	1.228361e+12	4.964	272.000000	0.067038	11.405977	0.191536	0.075695	-0.023719	0.054524	742.0	25.281769	0
7194162	1.511828e+12	7.000	49.703369	0.007925	-8.033231	0.388345	-0.050394	0.024747	0.028131	499.0	25.596136	0
7194163	1.460289e+12	6.000	246.000000	0.014366	8.281796	0.979258	-0.074037	-0.002198	-0.041655	943.0	25.008970	1

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows